﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsTraining" targetNamespace="http://tempuri.org/dsTraining.xsd" xmlns:mstns="http://tempuri.org/dsTraining.xsd" xmlns="http://tempuri.org/dsTraining.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CrewManagmentConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CrewManagmentConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QLTV.Properties.Settings.GlobalReference.Default.CrewManagmentConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblTrainingCrewsTableAdapter" GeneratorDataComponentClassName="tblTrainingCrewsTableAdapter" Name="tblTrainingCrews" UserDataComponentName="tblTrainingCrewsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblTrainingCrews" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblTrainingCrews] WHERE (([nTrainingCrewId] = @Original_nTrainingCrewId) AND ((@IsNull_nTrainingCourse = 1 AND [nTrainingCourse] IS NULL) OR ([nTrainingCourse] = @Original_nTrainingCourse)) AND ((@IsNull_nCrewId = 1 AND [nCrewId] IS NULL) OR ([nCrewId] = @Original_nCrewId)) AND ((@IsNull_dFromDate = 1 AND [dFromDate] IS NULL) OR ([dFromDate] = @Original_dFromDate)) AND ((@IsNull_dToDate = 1 AND [dToDate] IS NULL) OR ([dToDate] = @Original_dToDate)) AND ((@IsNull_cFullName = 1 AND [cFullName] IS NULL) OR ([cFullName] = @Original_cFullName)) AND ((@IsNull_cDescription = 1 AND [cDescription] IS NULL) OR ([cDescription] = @Original_cDescription)) AND ((@IsNull_isConfirm = 1 AND [isConfirm] IS NULL) OR ([isConfirm] = @Original_isConfirm)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nTrainingCrewId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nTrainingCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nTrainingCourse" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nTrainingCourse" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nTrainingCourse" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nTrainingCourse" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCrewId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dFromDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dFromDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dFromDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dFromDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dToDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dToDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dToDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dToDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cFullName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cFullName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cFullName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFullName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isConfirm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isConfirm" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isConfirm" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isConfirm" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblTrainingCrews] ([nTrainingCourse], [nCrewId], [dFromDate], [dToDate], [cFullName], [cDescription], [isConfirm]) VALUES (@nTrainingCourse, @nCrewId, @dFromDate, @dToDate, @cFullName, @cDescription, @isConfirm);
SELECT nTrainingCrewId, nTrainingCourse, nCrewId, dFromDate, dToDate, cFullName, cDescription, isConfirm FROM tblTrainingCrews WHERE (nTrainingCrewId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nTrainingCourse" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nTrainingCourse" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dFromDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dFromDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dToDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dToDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cFullName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFullName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isConfirm" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isConfirm" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        nTrainingCrewId, nTrainingCourse, nCrewId, dFromDate, dToDate, cFullName, cDescription, isConfirm
FROM            tblTrainingCrews</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblTrainingCrews] SET [nTrainingCourse] = @nTrainingCourse, [nCrewId] = @nCrewId, [dFromDate] = @dFromDate, [dToDate] = @dToDate, [cFullName] = @cFullName, [cDescription] = @cDescription, [isConfirm] = @isConfirm WHERE (([nTrainingCrewId] = @Original_nTrainingCrewId) AND ((@IsNull_nTrainingCourse = 1 AND [nTrainingCourse] IS NULL) OR ([nTrainingCourse] = @Original_nTrainingCourse)) AND ((@IsNull_nCrewId = 1 AND [nCrewId] IS NULL) OR ([nCrewId] = @Original_nCrewId)) AND ((@IsNull_dFromDate = 1 AND [dFromDate] IS NULL) OR ([dFromDate] = @Original_dFromDate)) AND ((@IsNull_dToDate = 1 AND [dToDate] IS NULL) OR ([dToDate] = @Original_dToDate)) AND ((@IsNull_cFullName = 1 AND [cFullName] IS NULL) OR ([cFullName] = @Original_cFullName)) AND ((@IsNull_cDescription = 1 AND [cDescription] IS NULL) OR ([cDescription] = @Original_cDescription)) AND ((@IsNull_isConfirm = 1 AND [isConfirm] IS NULL) OR ([isConfirm] = @Original_isConfirm)));
SELECT nTrainingCrewId, nTrainingCourse, nCrewId, dFromDate, dToDate, cFullName, cDescription, isConfirm FROM tblTrainingCrews WHERE (nTrainingCrewId = @nTrainingCrewId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nTrainingCourse" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nTrainingCourse" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dFromDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dFromDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dToDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dToDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cFullName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFullName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isConfirm" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isConfirm" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nTrainingCrewId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nTrainingCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nTrainingCourse" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nTrainingCourse" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nTrainingCourse" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nTrainingCourse" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCrewId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dFromDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dFromDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dFromDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dFromDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dToDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dToDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dToDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dToDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cFullName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cFullName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cFullName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFullName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isConfirm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isConfirm" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isConfirm" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isConfirm" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nTrainingCrewId" ColumnName="nTrainingCrewId" DataSourceName="CrewManagment.dbo.tblTrainingCrews" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nTrainingCrewId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nTrainingCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nTrainingCrewId" DataSetColumn="nTrainingCrewId" />
              <Mapping SourceColumn="nTrainingCourse" DataSetColumn="nTrainingCourse" />
              <Mapping SourceColumn="nCrewId" DataSetColumn="nCrewId" />
              <Mapping SourceColumn="dFromDate" DataSetColumn="dFromDate" />
              <Mapping SourceColumn="dToDate" DataSetColumn="dToDate" />
              <Mapping SourceColumn="cFullName" DataSetColumn="cFullName" />
              <Mapping SourceColumn="cDescription" DataSetColumn="cDescription" />
              <Mapping SourceColumn="isConfirm" DataSetColumn="isConfirm" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblTrainingCrews" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByConfirm" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByConfirm" GeneratorSourceName="FillByConfirm" GetMethodModifier="Public" GetMethodName="GetDataByConfirm" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByConfirm" UserSourceName="FillByConfirm">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        nTrainingCrewId, nTrainingCourse, nCrewId, dFromDate, dToDate, cFullName, cDescription, isConfirm
FROM            tblTrainingCrews
where isConfirm =1</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblTrainingCrews" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCrew" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCrew" GeneratorSourceName="FillByCrew" GetMethodModifier="Public" GetMethodName="GetDataByCrew" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCrew" UserSourceName="FillByCrew">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        nTrainingCrewId, nTrainingCourse, nCrewId, dFromDate, dToDate, cFullName, cDescription, isConfirm
FROM            tblTrainingCrews
where nCrewId=@crewID and isConfirm=1</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="crewID" ColumnName="nCrewId" DataSourceName="CrewManagment.dbo.tblTrainingCrews" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@crewID" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblTrainingCourseTableAdapter" GeneratorDataComponentClassName="tblTrainingCourseTableAdapter" Name="tblTrainingCourse" UserDataComponentName="tblTrainingCourseTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblTrainingCourse" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblTrainingCourse] WHERE (([nTrainingCourse] = @Original_nTrainingCourse) AND ((@IsNull_cCourseName = 1 AND [cCourseName] IS NULL) OR ([cCourseName] = @Original_cCourseName)) AND ((@IsNull_cCourseDescription = 1 AND [cCourseDescription] IS NULL) OR ([cCourseDescription] = @Original_cCourseDescription)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nTrainingCourse" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nTrainingCourse" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cCourseName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cCourseName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cCourseName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cCourseName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cCourseDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cCourseDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cCourseDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cCourseDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblTrainingCourse] ([cCourseName], [cCourseDescription]) VALUES (@cCourseName, @cCourseDescription);
SELECT nTrainingCourse, cCourseName, cCourseDescription FROM tblTrainingCourse WHERE (nTrainingCourse = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cCourseName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cCourseName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cCourseDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cCourseDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT nTrainingCourse, cCourseName, cCourseDescription FROM dbo.tblTrainingCourse</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblTrainingCourse] SET [cCourseName] = @cCourseName, [cCourseDescription] = @cCourseDescription WHERE (([nTrainingCourse] = @Original_nTrainingCourse) AND ((@IsNull_cCourseName = 1 AND [cCourseName] IS NULL) OR ([cCourseName] = @Original_cCourseName)) AND ((@IsNull_cCourseDescription = 1 AND [cCourseDescription] IS NULL) OR ([cCourseDescription] = @Original_cCourseDescription)));
SELECT nTrainingCourse, cCourseName, cCourseDescription FROM tblTrainingCourse WHERE (nTrainingCourse = @nTrainingCourse)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cCourseName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cCourseName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cCourseDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cCourseDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nTrainingCourse" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nTrainingCourse" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cCourseName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cCourseName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cCourseName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cCourseName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cCourseDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cCourseDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cCourseDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cCourseDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nTrainingCourse" ColumnName="nTrainingCourse" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nTrainingCourse" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nTrainingCourse" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nTrainingCourse" DataSetColumn="nTrainingCourse" />
              <Mapping SourceColumn="cCourseName" DataSetColumn="cCourseName" />
              <Mapping SourceColumn="cCourseDescription" DataSetColumn="cCourseDescription" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblCrewTableAdapter" GeneratorDataComponentClassName="tblCrewTableAdapter" Name="tblCrew" UserDataComponentName="tblCrewTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblCrew" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblCrew] WHERE (([nCrewId] = @Original_nCrewId) AND ((@IsNull_nRankID = 1 AND [nRankID] IS NULL) OR ([nRankID] = @Original_nRankID)) AND ((@IsNull_iCrewType = 1 AND [iCrewType] IS NULL) OR ([iCrewType] = @Original_iCrewType)) AND ((@IsNull_cFamilyName = 1 AND [cFamilyName] IS NULL) OR ([cFamilyName] = @Original_cFamilyName)) AND ((@IsNull_cMiddleName = 1 AND [cMiddleName] IS NULL) OR ([cMiddleName] = @Original_cMiddleName)) AND ((@IsNull_cFirstName = 1 AND [cFirstName] IS NULL) OR ([cFirstName] = @Original_cFirstName)) AND ((@IsNull_cCMT = 1 AND [cCMT] IS NULL) OR ([cCMT] = @Original_cCMT)) AND ((@IsNull_dNgayCap = 1 AND [dNgayCap] IS NULL) OR ([dNgayCap] = @Original_dNgayCap)) AND ((@IsNull_nNoiCap = 1 AND [nNoiCap] IS NULL) OR ([nNoiCap] = @Original_nNoiCap)) AND ((@IsNull_cAlias = 1 AND [cAlias] IS NULL) OR ([cAlias] = @Original_cAlias)) AND ((@IsNull_dDateOfBirth = 1 AND [dDateOfBirth] IS NULL) OR ([dDateOfBirth] = @Original_dDateOfBirth)) AND ((@IsNull_cAddress = 1 AND [cAddress] IS NULL) OR ([cAddress] = @Original_cAddress)) AND ((@IsNull_cPlaceOfBirth = 1 AND [cPlaceOfBirth] IS NULL) OR ([cPlaceOfBirth] = @Original_cPlaceOfBirth)) AND ((@IsNull_cHomeNo = 1 AND [cHomeNo] IS NULL) OR ([cHomeNo] = @Original_cHomeNo)) AND ((@IsNull_cHandNo = 1 AND [cHandNo] IS NULL) OR ([cHandNo] = @Original_cHandNo)) AND ((@IsNull_cEmail = 1 AND [cEmail] IS NULL) OR ([cEmail] = @Original_cEmail)) AND ((@IsNull_cSex = 1 AND [cSex] IS NULL) OR ([cSex] = @Original_cSex)) AND ((@IsNull_cMaritalStatus = 1 AND [cMaritalStatus] IS NULL) OR ([cMaritalStatus] = @Original_cMaritalStatus)) AND ((@IsNull_cNationality = 1 AND [cNationality] IS NULL) OR ([cNationality] = @Original_cNationality)) AND ((@IsNull_cContactPerson = 1 AND [cContactPerson] IS NULL) OR ([cContactPerson] = @Original_cContactPerson)) AND ((@IsNull_cContactPersonAddress = 1 AND [cContactPersonAddress] IS NULL) OR ([cContactPersonAddress] = @Original_cContactPersonAddress)) AND ((@IsNull_cContactPersonNo = 1 AND [cContactPersonNo] IS NULL) OR ([cContactPersonNo] = @Original_cContactPersonNo)) AND ((@IsNull_cContactRelation = 1 AND [cContactRelation] IS NULL) OR ([cContactRelation] = @Original_cContactRelation)) AND ((@IsNull_cContactEmail = 1 AND [cContactEmail] IS NULL) OR ([cContactEmail] = @Original_cContactEmail)) AND ((@IsNull_fHeight = 1 AND [fHeight] IS NULL) OR ([fHeight] = @Original_fHeight)) AND ((@IsNull_fWeight = 1 AND [fWeight] IS NULL) OR ([fWeight] = @Original_fWeight)) AND ((@IsNull_cBloodGroup = 1 AND [cBloodGroup] IS NULL) OR ([cBloodGroup] = @Original_cBloodGroup)) AND ((@IsNull_fShoeSizeVN = 1 AND [fShoeSizeVN] IS NULL) OR ([fShoeSizeVN] = @Original_fShoeSizeVN)) AND ((@IsNull_fShoeSizeJP = 1 AND [fShoeSizeJP] IS NULL) OR ([fShoeSizeJP] = @Original_fShoeSizeJP)) AND ((@IsNull_fOverallSizeVN = 1 AND [fOverallSizeVN] IS NULL) OR ([fOverallSizeVN] = @Original_fOverallSizeVN)) AND ((@IsNull_cOverallSizeJP = 1 AND [cOverallSizeJP] IS NULL) OR ([cOverallSizeJP] = @Original_cOverallSizeJP)) AND ((@IsNull_bDeleted = 1 AND [bDeleted] IS NULL) OR ([bDeleted] = @Original_bDeleted)) AND ((@IsNull_ContactPhuongXaID = 1 AND [ContactPhuongXaID] IS NULL) OR ([ContactPhuongXaID] = @Original_ContactPhuongXaID)) AND ((@IsNull_ContactQuanHuyenId = 1 AND [ContactQuanHuyenId] IS NULL) OR ([ContactQuanHuyenId] = @Original_ContactQuanHuyenId)) AND ((@IsNull_ContactTinhThanh = 1 AND [ContactTinhThanh] IS NULL) OR ([ContactTinhThanh] = @Original_ContactTinhThanh)) AND ((@IsNull_PhuongXaID = 1 AND [PhuongXaID] IS NULL) OR ([PhuongXaID] = @Original_PhuongXaID)) AND ((@IsNull_QuanHuyenID = 1 AND [QuanHuyenID] IS NULL) OR ([QuanHuyenID] = @Original_QuanHuyenID)) AND ((@IsNull_TinhThanhID = 1 AND [TinhThanhID] IS NULL) OR ([TinhThanhID] = @Original_TinhThanhID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cFamilyName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cFamilyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMiddleName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cMiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cFirstName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cFirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cCMT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cCMT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cCMT" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cCMT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dNgayCap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dNgayCap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dNgayCap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dNgayCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nNoiCap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nNoiCap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nNoiCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nNoiCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cAlias" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cAlias" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDateOfBirth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDateOfBirth" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cPlaceOfBirth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cPlaceOfBirth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cHomeNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cHomeNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cHandNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cHandNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cEmail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cSex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cSex" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cSex" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cSex" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMaritalStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cMaritalStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cNationality" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cNationality" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPerson" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactPerson" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPersonAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactPersonAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPersonNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cContactPersonNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactRelation" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactRelation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactEmail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cContactEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fHeight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fWeight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fWeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cBloodGroup" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cBloodGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fShoeSizeVN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fShoeSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fShoeSizeJP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fShoeSizeJP" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fOverallSizeVN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fOverallSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cOverallSizeJP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cOverallSizeJP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactPhuongXaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactPhuongXaID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ContactPhuongXaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactPhuongXaID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactQuanHuyenId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactQuanHuyenId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ContactQuanHuyenId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactQuanHuyenId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactTinhThanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactTinhThanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ContactTinhThanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactTinhThanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PhuongXaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhuongXaID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PhuongXaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhuongXaID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_QuanHuyenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuanHuyenID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QuanHuyenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuanHuyenID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TinhThanhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TinhThanhID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TinhThanhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TinhThanhID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblCrew] ([nCrewId], [nRankID], [iCrewType], [bImage], [cFamilyName], [cMiddleName], [cFirstName], [cCMT], [dNgayCap], [nNoiCap], [cAlias], [dDateOfBirth], [cAddress], [cPlaceOfBirth], [cHomeNo], [cHandNo], [cEmail], [cSex], [cMaritalStatus], [cNationality], [cContactPerson], [cContactPersonAddress], [cContactPersonNo], [cContactRelation], [cContactEmail], [fHeight], [fWeight], [cBloodGroup], [fShoeSizeVN], [fShoeSizeJP], [fOverallSizeVN], [cOverallSizeJP], [bDeleted], [ContactPhuongXaID], [ContactQuanHuyenId], [ContactTinhThanh], [PhuongXaID], [QuanHuyenID], [TinhThanhID]) VALUES (@nCrewId, @nRankID, @iCrewType, @bImage, @cFamilyName, @cMiddleName, @cFirstName, @cCMT, @dNgayCap, @nNoiCap, @cAlias, @dDateOfBirth, @cAddress, @cPlaceOfBirth, @cHomeNo, @cHandNo, @cEmail, @cSex, @cMaritalStatus, @cNationality, @cContactPerson, @cContactPersonAddress, @cContactPersonNo, @cContactRelation, @cContactEmail, @fHeight, @fWeight, @cBloodGroup, @fShoeSizeVN, @fShoeSizeJP, @fOverallSizeVN, @cOverallSizeJP, @bDeleted, @ContactPhuongXaID, @ContactQuanHuyenId, @ContactTinhThanh, @PhuongXaID, @QuanHuyenID, @TinhThanhID);
SELECT nCrewId, nRankID, iCrewType, bImage, cFamilyName, cMiddleName, cFirstName, cCMT, dNgayCap, nNoiCap, cAlias, dDateOfBirth, cAddress, cPlaceOfBirth, cHomeNo, cHandNo, cEmail, cSex, cMaritalStatus, cNationality, cContactPerson, cContactPersonAddress, cContactPersonNo, cContactRelation, cContactEmail, fHeight, fWeight, cBloodGroup, fShoeSizeVN, fShoeSizeJP, fOverallSizeVN, cOverallSizeJP, bDeleted, ContactPhuongXaID, ContactQuanHuyenId, ContactTinhThanh, PhuongXaID, QuanHuyenID, TinhThanhID FROM tblCrew WHERE (nCrewId = @nCrewId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@bImage" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="bImage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cFamilyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cMiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cFirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cCMT" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cCMT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dNgayCap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dNgayCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nNoiCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nNoiCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cAlias" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDateOfBirth" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cPlaceOfBirth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cHomeNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cHandNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cSex" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cSex" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cMaritalStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cNationality" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactPerson" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactPersonAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cContactPersonNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactRelation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cContactEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fWeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cBloodGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fShoeSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fShoeSizeJP" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fOverallSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cOverallSizeJP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ContactPhuongXaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactPhuongXaID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ContactQuanHuyenId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactQuanHuyenId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ContactTinhThanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactTinhThanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PhuongXaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhuongXaID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QuanHuyenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuanHuyenID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TinhThanhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TinhThanhID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT nCrewId, nRankID, iCrewType, bImage, cFamilyName, cMiddleName, cFirstName, cCMT, dNgayCap, nNoiCap, cAlias, dDateOfBirth, cAddress, cPlaceOfBirth, cHomeNo, cHandNo, cEmail, cSex, cMaritalStatus, cNationality, cContactPerson, cContactPersonAddress, cContactPersonNo, cContactRelation, cContactEmail, fHeight, fWeight, cBloodGroup, fShoeSizeVN, fShoeSizeJP, fOverallSizeVN, cOverallSizeJP, bDeleted, ContactPhuongXaID, ContactQuanHuyenId, ContactTinhThanh, PhuongXaID, QuanHuyenID, TinhThanhID FROM dbo.tblCrew</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblCrew] SET [nCrewId] = @nCrewId, [nRankID] = @nRankID, [iCrewType] = @iCrewType, [bImage] = @bImage, [cFamilyName] = @cFamilyName, [cMiddleName] = @cMiddleName, [cFirstName] = @cFirstName, [cCMT] = @cCMT, [dNgayCap] = @dNgayCap, [nNoiCap] = @nNoiCap, [cAlias] = @cAlias, [dDateOfBirth] = @dDateOfBirth, [cAddress] = @cAddress, [cPlaceOfBirth] = @cPlaceOfBirth, [cHomeNo] = @cHomeNo, [cHandNo] = @cHandNo, [cEmail] = @cEmail, [cSex] = @cSex, [cMaritalStatus] = @cMaritalStatus, [cNationality] = @cNationality, [cContactPerson] = @cContactPerson, [cContactPersonAddress] = @cContactPersonAddress, [cContactPersonNo] = @cContactPersonNo, [cContactRelation] = @cContactRelation, [cContactEmail] = @cContactEmail, [fHeight] = @fHeight, [fWeight] = @fWeight, [cBloodGroup] = @cBloodGroup, [fShoeSizeVN] = @fShoeSizeVN, [fShoeSizeJP] = @fShoeSizeJP, [fOverallSizeVN] = @fOverallSizeVN, [cOverallSizeJP] = @cOverallSizeJP, [bDeleted] = @bDeleted, [ContactPhuongXaID] = @ContactPhuongXaID, [ContactQuanHuyenId] = @ContactQuanHuyenId, [ContactTinhThanh] = @ContactTinhThanh, [PhuongXaID] = @PhuongXaID, [QuanHuyenID] = @QuanHuyenID, [TinhThanhID] = @TinhThanhID WHERE (([nCrewId] = @Original_nCrewId) AND ((@IsNull_nRankID = 1 AND [nRankID] IS NULL) OR ([nRankID] = @Original_nRankID)) AND ((@IsNull_iCrewType = 1 AND [iCrewType] IS NULL) OR ([iCrewType] = @Original_iCrewType)) AND ((@IsNull_cFamilyName = 1 AND [cFamilyName] IS NULL) OR ([cFamilyName] = @Original_cFamilyName)) AND ((@IsNull_cMiddleName = 1 AND [cMiddleName] IS NULL) OR ([cMiddleName] = @Original_cMiddleName)) AND ((@IsNull_cFirstName = 1 AND [cFirstName] IS NULL) OR ([cFirstName] = @Original_cFirstName)) AND ((@IsNull_cCMT = 1 AND [cCMT] IS NULL) OR ([cCMT] = @Original_cCMT)) AND ((@IsNull_dNgayCap = 1 AND [dNgayCap] IS NULL) OR ([dNgayCap] = @Original_dNgayCap)) AND ((@IsNull_nNoiCap = 1 AND [nNoiCap] IS NULL) OR ([nNoiCap] = @Original_nNoiCap)) AND ((@IsNull_cAlias = 1 AND [cAlias] IS NULL) OR ([cAlias] = @Original_cAlias)) AND ((@IsNull_dDateOfBirth = 1 AND [dDateOfBirth] IS NULL) OR ([dDateOfBirth] = @Original_dDateOfBirth)) AND ((@IsNull_cAddress = 1 AND [cAddress] IS NULL) OR ([cAddress] = @Original_cAddress)) AND ((@IsNull_cPlaceOfBirth = 1 AND [cPlaceOfBirth] IS NULL) OR ([cPlaceOfBirth] = @Original_cPlaceOfBirth)) AND ((@IsNull_cHomeNo = 1 AND [cHomeNo] IS NULL) OR ([cHomeNo] = @Original_cHomeNo)) AND ((@IsNull_cHandNo = 1 AND [cHandNo] IS NULL) OR ([cHandNo] = @Original_cHandNo)) AND ((@IsNull_cEmail = 1 AND [cEmail] IS NULL) OR ([cEmail] = @Original_cEmail)) AND ((@IsNull_cSex = 1 AND [cSex] IS NULL) OR ([cSex] = @Original_cSex)) AND ((@IsNull_cMaritalStatus = 1 AND [cMaritalStatus] IS NULL) OR ([cMaritalStatus] = @Original_cMaritalStatus)) AND ((@IsNull_cNationality = 1 AND [cNationality] IS NULL) OR ([cNationality] = @Original_cNationality)) AND ((@IsNull_cContactPerson = 1 AND [cContactPerson] IS NULL) OR ([cContactPerson] = @Original_cContactPerson)) AND ((@IsNull_cContactPersonAddress = 1 AND [cContactPersonAddress] IS NULL) OR ([cContactPersonAddress] = @Original_cContactPersonAddress)) AND ((@IsNull_cContactPersonNo = 1 AND [cContactPersonNo] IS NULL) OR ([cContactPersonNo] = @Original_cContactPersonNo)) AND ((@IsNull_cContactRelation = 1 AND [cContactRelation] IS NULL) OR ([cContactRelation] = @Original_cContactRelation)) AND ((@IsNull_cContactEmail = 1 AND [cContactEmail] IS NULL) OR ([cContactEmail] = @Original_cContactEmail)) AND ((@IsNull_fHeight = 1 AND [fHeight] IS NULL) OR ([fHeight] = @Original_fHeight)) AND ((@IsNull_fWeight = 1 AND [fWeight] IS NULL) OR ([fWeight] = @Original_fWeight)) AND ((@IsNull_cBloodGroup = 1 AND [cBloodGroup] IS NULL) OR ([cBloodGroup] = @Original_cBloodGroup)) AND ((@IsNull_fShoeSizeVN = 1 AND [fShoeSizeVN] IS NULL) OR ([fShoeSizeVN] = @Original_fShoeSizeVN)) AND ((@IsNull_fShoeSizeJP = 1 AND [fShoeSizeJP] IS NULL) OR ([fShoeSizeJP] = @Original_fShoeSizeJP)) AND ((@IsNull_fOverallSizeVN = 1 AND [fOverallSizeVN] IS NULL) OR ([fOverallSizeVN] = @Original_fOverallSizeVN)) AND ((@IsNull_cOverallSizeJP = 1 AND [cOverallSizeJP] IS NULL) OR ([cOverallSizeJP] = @Original_cOverallSizeJP)) AND ((@IsNull_bDeleted = 1 AND [bDeleted] IS NULL) OR ([bDeleted] = @Original_bDeleted)) AND ((@IsNull_ContactPhuongXaID = 1 AND [ContactPhuongXaID] IS NULL) OR ([ContactPhuongXaID] = @Original_ContactPhuongXaID)) AND ((@IsNull_ContactQuanHuyenId = 1 AND [ContactQuanHuyenId] IS NULL) OR ([ContactQuanHuyenId] = @Original_ContactQuanHuyenId)) AND ((@IsNull_ContactTinhThanh = 1 AND [ContactTinhThanh] IS NULL) OR ([ContactTinhThanh] = @Original_ContactTinhThanh)) AND ((@IsNull_PhuongXaID = 1 AND [PhuongXaID] IS NULL) OR ([PhuongXaID] = @Original_PhuongXaID)) AND ((@IsNull_QuanHuyenID = 1 AND [QuanHuyenID] IS NULL) OR ([QuanHuyenID] = @Original_QuanHuyenID)) AND ((@IsNull_TinhThanhID = 1 AND [TinhThanhID] IS NULL) OR ([TinhThanhID] = @Original_TinhThanhID)));
SELECT nCrewId, nRankID, iCrewType, bImage, cFamilyName, cMiddleName, cFirstName, cCMT, dNgayCap, nNoiCap, cAlias, dDateOfBirth, cAddress, cPlaceOfBirth, cHomeNo, cHandNo, cEmail, cSex, cMaritalStatus, cNationality, cContactPerson, cContactPersonAddress, cContactPersonNo, cContactRelation, cContactEmail, fHeight, fWeight, cBloodGroup, fShoeSizeVN, fShoeSizeJP, fOverallSizeVN, cOverallSizeJP, bDeleted, ContactPhuongXaID, ContactQuanHuyenId, ContactTinhThanh, PhuongXaID, QuanHuyenID, TinhThanhID FROM tblCrew WHERE (nCrewId = @nCrewId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@bImage" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="bImage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cFamilyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cMiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cFirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cCMT" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cCMT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dNgayCap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dNgayCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nNoiCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nNoiCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cAlias" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDateOfBirth" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cPlaceOfBirth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cHomeNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cHandNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cSex" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cSex" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cMaritalStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cNationality" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactPerson" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactPersonAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cContactPersonNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactRelation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cContactEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fWeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cBloodGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fShoeSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fShoeSizeJP" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fOverallSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cOverallSizeJP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ContactPhuongXaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactPhuongXaID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ContactQuanHuyenId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactQuanHuyenId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ContactTinhThanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactTinhThanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PhuongXaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhuongXaID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QuanHuyenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuanHuyenID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TinhThanhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TinhThanhID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cFamilyName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cFamilyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMiddleName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cMiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cFirstName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cFirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cCMT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cCMT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cCMT" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cCMT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dNgayCap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dNgayCap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dNgayCap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dNgayCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nNoiCap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nNoiCap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nNoiCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nNoiCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cAlias" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cAlias" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDateOfBirth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDateOfBirth" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cPlaceOfBirth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cPlaceOfBirth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cHomeNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cHomeNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cHandNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cHandNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cEmail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cSex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cSex" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cSex" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cSex" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMaritalStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cMaritalStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cNationality" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cNationality" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPerson" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactPerson" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPersonAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactPersonAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPersonNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cContactPersonNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactRelation" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactRelation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactEmail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cContactEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fHeight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fWeight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fWeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cBloodGroup" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cBloodGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fShoeSizeVN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fShoeSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fShoeSizeJP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fShoeSizeJP" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fOverallSizeVN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fOverallSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cOverallSizeJP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cOverallSizeJP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactPhuongXaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactPhuongXaID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ContactPhuongXaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactPhuongXaID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactQuanHuyenId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactQuanHuyenId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ContactQuanHuyenId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactQuanHuyenId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactTinhThanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactTinhThanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ContactTinhThanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactTinhThanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PhuongXaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhuongXaID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PhuongXaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhuongXaID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_QuanHuyenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuanHuyenID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QuanHuyenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuanHuyenID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TinhThanhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TinhThanhID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TinhThanhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TinhThanhID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nCrewId" DataSetColumn="nCrewId" />
              <Mapping SourceColumn="nRankID" DataSetColumn="nRankID" />
              <Mapping SourceColumn="iCrewType" DataSetColumn="iCrewType" />
              <Mapping SourceColumn="bImage" DataSetColumn="bImage" />
              <Mapping SourceColumn="cFamilyName" DataSetColumn="cFamilyName" />
              <Mapping SourceColumn="cMiddleName" DataSetColumn="cMiddleName" />
              <Mapping SourceColumn="cFirstName" DataSetColumn="cFirstName" />
              <Mapping SourceColumn="cCMT" DataSetColumn="cCMT" />
              <Mapping SourceColumn="dNgayCap" DataSetColumn="dNgayCap" />
              <Mapping SourceColumn="nNoiCap" DataSetColumn="nNoiCap" />
              <Mapping SourceColumn="cAlias" DataSetColumn="cAlias" />
              <Mapping SourceColumn="dDateOfBirth" DataSetColumn="dDateOfBirth" />
              <Mapping SourceColumn="cAddress" DataSetColumn="cAddress" />
              <Mapping SourceColumn="cPlaceOfBirth" DataSetColumn="cPlaceOfBirth" />
              <Mapping SourceColumn="cHomeNo" DataSetColumn="cHomeNo" />
              <Mapping SourceColumn="cHandNo" DataSetColumn="cHandNo" />
              <Mapping SourceColumn="cEmail" DataSetColumn="cEmail" />
              <Mapping SourceColumn="cSex" DataSetColumn="cSex" />
              <Mapping SourceColumn="cMaritalStatus" DataSetColumn="cMaritalStatus" />
              <Mapping SourceColumn="cNationality" DataSetColumn="cNationality" />
              <Mapping SourceColumn="cContactPerson" DataSetColumn="cContactPerson" />
              <Mapping SourceColumn="cContactPersonAddress" DataSetColumn="cContactPersonAddress" />
              <Mapping SourceColumn="cContactPersonNo" DataSetColumn="cContactPersonNo" />
              <Mapping SourceColumn="cContactRelation" DataSetColumn="cContactRelation" />
              <Mapping SourceColumn="cContactEmail" DataSetColumn="cContactEmail" />
              <Mapping SourceColumn="fHeight" DataSetColumn="fHeight" />
              <Mapping SourceColumn="fWeight" DataSetColumn="fWeight" />
              <Mapping SourceColumn="cBloodGroup" DataSetColumn="cBloodGroup" />
              <Mapping SourceColumn="fShoeSizeVN" DataSetColumn="fShoeSizeVN" />
              <Mapping SourceColumn="fShoeSizeJP" DataSetColumn="fShoeSizeJP" />
              <Mapping SourceColumn="fOverallSizeVN" DataSetColumn="fOverallSizeVN" />
              <Mapping SourceColumn="cOverallSizeJP" DataSetColumn="cOverallSizeJP" />
              <Mapping SourceColumn="bDeleted" DataSetColumn="bDeleted" />
              <Mapping SourceColumn="ContactPhuongXaID" DataSetColumn="ContactPhuongXaID" />
              <Mapping SourceColumn="ContactQuanHuyenId" DataSetColumn="ContactQuanHuyenId" />
              <Mapping SourceColumn="ContactTinhThanh" DataSetColumn="ContactTinhThanh" />
              <Mapping SourceColumn="PhuongXaID" DataSetColumn="PhuongXaID" />
              <Mapping SourceColumn="QuanHuyenID" DataSetColumn="QuanHuyenID" />
              <Mapping SourceColumn="TinhThanhID" DataSetColumn="TinhThanhID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblCrew" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByDate" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByDate" GeneratorSourceName="FillByDate" GetMethodModifier="Public" GetMethodName="GetDataByDate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByDate" UserSourceName="FillByDate">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT    tblCrew.nCrewId, tblCrew.nRankID, tblCrew.iCrewType, tblCrew.bImage, tblCrew.cFamilyName, tblCrew.cMiddleName, tblCrew.cFirstName, tblCrew.cCMT, 
                         tblCrew.dNgayCap, tblCrew.nNoiCap, tblCrew.cAlias, tblCrew.dDateOfBirth, tblCrew.cAddress, tblCrew.cPlaceOfBirth, tblCrew.cHomeNo, tblCrew.cHandNo, 
                         tblCrew.cEmail, tblCrew.cSex, tblCrew.cMaritalStatus, tblCrew.cNationality, tblCrew.cContactPerson, tblCrew.cContactPersonAddress, tblCrew.cContactPersonNo, 
                         tblCrew.cContactRelation, tblCrew.cContactEmail, tblCrew.fHeight, tblCrew.fWeight, tblCrew.cBloodGroup, tblCrew.fShoeSizeVN, tblCrew.fShoeSizeJP, 
                         tblCrew.fOverallSizeVN, tblCrew.cOverallSizeJP, tblCrew.bDeleted, tblCrew.ContactPhuongXaID, tblCrew.ContactQuanHuyenId, tblCrew.ContactTinhThanh, 
                         tblCrew.PhuongXaID, tblCrew.QuanHuyenID, tblCrew.TinhThanhID
FROM            tblCrew INNER JOIN
                         tblAssignment ON tblCrew.nCrewId = tblAssignment.nCrewid
WHERE tblAssignment.isActive = 1 and (tblAssignment.cStatus = 'On Board' or tblAssignment.cStatus = 'On Vacation'
or tblAssignment.cStatus = 'New Crew') and (tblAssignment.dDuKienRoiTau &lt;= @StartDate or tblAssignment.dLeave &lt;= @StartDate)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="StartDate" ColumnName="dDuKienRoiTau" DataSourceName="CrewManagment.dbo.tblAssignment" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="dDuKienRoiTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblLongPlanVesselTableAdapter" GeneratorDataComponentClassName="tblLongPlanVesselTableAdapter" Name="tblLongPlanVessel" UserDataComponentName="tblLongPlanVesselTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblLongPlanVessel" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblLongPlanVessel] WHERE (([nLongPlanVesselId] = @Original_nLongPlanVesselId) AND ((@IsNull_nVesselId = 1 AND [nVesselId] IS NULL) OR ([nVesselId] = @Original_nVesselId)) AND ((@IsNull_nCrewId = 1 AND [nCrewId] IS NULL) OR ([nCrewId] = @Original_nCrewId)) AND ((@IsNull_VesselName = 1 AND [VesselName] IS NULL) OR ([VesselName] = @Original_VesselName)) AND ((@IsNull_FullName = 1 AND [FullName] IS NULL) OR ([FullName] = @Original_FullName)) AND ((@IsNull_dStart = 1 AND [dStart] IS NULL) OR ([dStart] = @Original_dStart)) AND ((@IsNull_dEnd = 1 AND [dEnd] IS NULL) OR ([dEnd] = @Original_dEnd)) AND ((@IsNull_nRankId = 1 AND [nRankId] IS NULL) OR ([nRankId] = @Original_nRankId)) AND ((@IsNull_PlanID = 1 AND [PlanID] IS NULL) OR ([PlanID] = @Original_PlanID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nLongPlanVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nLongPlanVesselId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCrewId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VesselName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VesselName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_VesselName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VesselName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FullName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FullName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dStart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dStart" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dStart" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dStart" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dEnd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dEnd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dEnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PlanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlanID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PlanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlanID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblLongPlanVessel] ([nVesselId], [nCrewId], [VesselName], [FullName], [dStart], [dEnd], [nRankId], [PlanID]) VALUES (@nVesselId, @nCrewId, @VesselName, @FullName, @dStart, @dEnd, @nRankId, @PlanID);
SELECT nLongPlanVesselId, nVesselId, nCrewId, VesselName, FullName, dStart, dEnd, nRankId, PlanID FROM tblLongPlanVessel WHERE (nLongPlanVesselId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VesselName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VesselName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FullName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dStart" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dStart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dEnd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dEnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PlanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlanID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT nLongPlanVesselId, nVesselId, nCrewId, VesselName, FullName, dStart, dEnd, nRankId, PlanID FROM dbo.tblLongPlanVessel</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblLongPlanVessel] SET [nVesselId] = @nVesselId, [nCrewId] = @nCrewId, [VesselName] = @VesselName, [FullName] = @FullName, [dStart] = @dStart, [dEnd] = @dEnd, [nRankId] = @nRankId, [PlanID] = @PlanID WHERE (([nLongPlanVesselId] = @Original_nLongPlanVesselId) AND ((@IsNull_nVesselId = 1 AND [nVesselId] IS NULL) OR ([nVesselId] = @Original_nVesselId)) AND ((@IsNull_nCrewId = 1 AND [nCrewId] IS NULL) OR ([nCrewId] = @Original_nCrewId)) AND ((@IsNull_VesselName = 1 AND [VesselName] IS NULL) OR ([VesselName] = @Original_VesselName)) AND ((@IsNull_FullName = 1 AND [FullName] IS NULL) OR ([FullName] = @Original_FullName)) AND ((@IsNull_dStart = 1 AND [dStart] IS NULL) OR ([dStart] = @Original_dStart)) AND ((@IsNull_dEnd = 1 AND [dEnd] IS NULL) OR ([dEnd] = @Original_dEnd)) AND ((@IsNull_nRankId = 1 AND [nRankId] IS NULL) OR ([nRankId] = @Original_nRankId)) AND ((@IsNull_PlanID = 1 AND [PlanID] IS NULL) OR ([PlanID] = @Original_PlanID)));
SELECT nLongPlanVesselId, nVesselId, nCrewId, VesselName, FullName, dStart, dEnd, nRankId, PlanID FROM tblLongPlanVessel WHERE (nLongPlanVesselId = @nLongPlanVesselId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VesselName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VesselName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FullName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dStart" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dStart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dEnd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dEnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PlanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlanID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nLongPlanVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nLongPlanVesselId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCrewId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VesselName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VesselName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_VesselName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VesselName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FullName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FullName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dStart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dStart" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dStart" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dStart" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dEnd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dEnd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dEnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PlanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlanID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PlanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlanID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nLongPlanVesselId" ColumnName="nLongPlanVesselId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nLongPlanVesselId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nLongPlanVesselId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nLongPlanVesselId" DataSetColumn="nLongPlanVesselId" />
              <Mapping SourceColumn="nVesselId" DataSetColumn="nVesselId" />
              <Mapping SourceColumn="nCrewId" DataSetColumn="nCrewId" />
              <Mapping SourceColumn="VesselName" DataSetColumn="VesselName" />
              <Mapping SourceColumn="FullName" DataSetColumn="FullName" />
              <Mapping SourceColumn="dStart" DataSetColumn="dStart" />
              <Mapping SourceColumn="dEnd" DataSetColumn="dEnd" />
              <Mapping SourceColumn="nRankId" DataSetColumn="nRankId" />
              <Mapping SourceColumn="PlanID" DataSetColumn="PlanID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblLongPlanVessel" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByDate" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByDate" GeneratorSourceName="FillByDate" GetMethodModifier="Public" GetMethodName="GetDataByDate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByDate" UserSourceName="FillByDate">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT nLongPlanVesselId, nVesselId, nCrewId, VesselName, FullName, dStart, dEnd, nRankId, PlanID FROM dbo.tblLongPlanVessel where nCrewId = @nCrewId and (
(dStart &gt;= @Start and dEnd &lt;= @End) or
(dStart &lt;= @Start and @End between dStart and dEnd) or
(@Start between dStart and dEnd and dEnd &gt;= @End) or
(dStart &lt;= @Start and dEnd &gt;= @End)
)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="nCrewId" ColumnName="nCrewId" DataSourceName="CrewManagment.dbo.tblLongPlanVessel" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Start" ColumnName="dStart" DataSourceName="CrewManagment.dbo.tblLongPlanVessel" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@Start" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="dStart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="End" ColumnName="dEnd" DataSourceName="CrewManagment.dbo.tblLongPlanVessel" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@End" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="dEnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsTraining" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsTraining" msprop:Generator_UserDSName="dsTraining">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblTrainingCrews" msprop:Generator_TableClassName="tblTrainingCrewsDataTable" msprop:Generator_TableVarName="tabletblTrainingCrews" msprop:Generator_TablePropName="tblTrainingCrews" msprop:Generator_RowDeletingName="tblTrainingCrewsRowDeleting" msprop:Generator_UserTableName="tblTrainingCrews" msprop:Generator_RowChangingName="tblTrainingCrewsRowChanging" msprop:Generator_RowEvHandlerName="tblTrainingCrewsRowChangeEventHandler" msprop:Generator_RowDeletedName="tblTrainingCrewsRowDeleted" msprop:Generator_RowEvArgName="tblTrainingCrewsRowChangeEvent" msprop:Generator_RowChangedName="tblTrainingCrewsRowChanged" msprop:Generator_RowClassName="tblTrainingCrewsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nTrainingCrewId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnTrainingCrewId" msprop:Generator_ColumnPropNameInRow="nTrainingCrewId" msprop:Generator_ColumnPropNameInTable="nTrainingCrewIdColumn" msprop:Generator_UserColumnName="nTrainingCrewId" type="xs:int" />
              <xs:element name="nTrainingCourse" msprop:Generator_ColumnVarNameInTable="columnnTrainingCourse" msprop:Generator_ColumnPropNameInRow="nTrainingCourse" msprop:Generator_ColumnPropNameInTable="nTrainingCourseColumn" msprop:Generator_UserColumnName="nTrainingCourse" type="xs:int" minOccurs="0" />
              <xs:element name="nCrewId" msprop:Generator_ColumnVarNameInTable="columnnCrewId" msprop:Generator_ColumnPropNameInRow="nCrewId" msprop:Generator_ColumnPropNameInTable="nCrewIdColumn" msprop:Generator_UserColumnName="nCrewId" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dFromDate" msprop:Generator_ColumnVarNameInTable="columndFromDate" msprop:Generator_ColumnPropNameInRow="dFromDate" msprop:Generator_ColumnPropNameInTable="dFromDateColumn" msprop:Generator_UserColumnName="dFromDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dToDate" msprop:Generator_ColumnVarNameInTable="columndToDate" msprop:Generator_ColumnPropNameInRow="dToDate" msprop:Generator_ColumnPropNameInTable="dToDateColumn" msprop:Generator_UserColumnName="dToDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="cFullName" msprop:Generator_ColumnVarNameInTable="columncFullName" msprop:Generator_ColumnPropNameInRow="cFullName" msprop:Generator_ColumnPropNameInTable="cFullNameColumn" msprop:Generator_UserColumnName="cFullName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cDescription" msprop:Generator_ColumnVarNameInTable="columncDescription" msprop:Generator_ColumnPropNameInRow="cDescription" msprop:Generator_ColumnPropNameInTable="cDescriptionColumn" msprop:Generator_UserColumnName="cDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="isConfirm" msprop:Generator_ColumnVarNameInTable="columnisConfirm" msprop:Generator_ColumnPropNameInRow="isConfirm" msprop:Generator_ColumnPropNameInTable="isConfirmColumn" msprop:Generator_UserColumnName="isConfirm" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblTrainingCourse" msprop:Generator_TableClassName="tblTrainingCourseDataTable" msprop:Generator_TableVarName="tabletblTrainingCourse" msprop:Generator_TablePropName="tblTrainingCourse" msprop:Generator_RowDeletingName="tblTrainingCourseRowDeleting" msprop:Generator_UserTableName="tblTrainingCourse" msprop:Generator_RowChangingName="tblTrainingCourseRowChanging" msprop:Generator_RowEvHandlerName="tblTrainingCourseRowChangeEventHandler" msprop:Generator_RowDeletedName="tblTrainingCourseRowDeleted" msprop:Generator_RowEvArgName="tblTrainingCourseRowChangeEvent" msprop:Generator_RowChangedName="tblTrainingCourseRowChanged" msprop:Generator_RowClassName="tblTrainingCourseRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nTrainingCourse" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnTrainingCourse" msprop:Generator_ColumnPropNameInRow="nTrainingCourse" msprop:Generator_ColumnPropNameInTable="nTrainingCourseColumn" msprop:Generator_UserColumnName="nTrainingCourse" type="xs:int" />
              <xs:element name="cCourseName" msprop:Generator_ColumnVarNameInTable="columncCourseName" msprop:Generator_ColumnPropNameInRow="cCourseName" msprop:Generator_ColumnPropNameInTable="cCourseNameColumn" msprop:Generator_UserColumnName="cCourseName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cCourseDescription" msprop:Generator_ColumnVarNameInTable="columncCourseDescription" msprop:Generator_ColumnPropNameInRow="cCourseDescription" msprop:Generator_ColumnPropNameInTable="cCourseDescriptionColumn" msprop:Generator_UserColumnName="cCourseDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblCrew" msprop:Generator_TableClassName="tblCrewDataTable" msprop:Generator_TableVarName="tabletblCrew" msprop:Generator_TablePropName="tblCrew" msprop:Generator_RowDeletingName="tblCrewRowDeleting" msprop:Generator_UserTableName="tblCrew" msprop:Generator_RowChangingName="tblCrewRowChanging" msprop:Generator_RowEvHandlerName="tblCrewRowChangeEventHandler" msprop:Generator_RowDeletedName="tblCrewRowDeleted" msprop:Generator_RowEvArgName="tblCrewRowChangeEvent" msprop:Generator_RowChangedName="tblCrewRowChanged" msprop:Generator_RowClassName="tblCrewRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nCrewId" msprop:Generator_ColumnVarNameInTable="columnnCrewId" msprop:Generator_ColumnPropNameInRow="nCrewId" msprop:Generator_ColumnPropNameInTable="nCrewIdColumn" msprop:Generator_UserColumnName="nCrewId">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nRankID" msprop:Generator_ColumnVarNameInTable="columnnRankID" msprop:Generator_ColumnPropNameInRow="nRankID" msprop:Generator_ColumnPropNameInTable="nRankIDColumn" msprop:Generator_UserColumnName="nRankID" type="xs:int" minOccurs="0" />
              <xs:element name="iCrewType" msprop:Generator_ColumnVarNameInTable="columniCrewType" msprop:Generator_ColumnPropNameInRow="iCrewType" msprop:Generator_ColumnPropNameInTable="iCrewTypeColumn" msprop:Generator_UserColumnName="iCrewType" type="xs:int" minOccurs="0" />
              <xs:element name="bImage" msprop:Generator_ColumnVarNameInTable="columnbImage" msprop:Generator_ColumnPropNameInRow="bImage" msprop:Generator_ColumnPropNameInTable="bImageColumn" msprop:Generator_UserColumnName="bImage" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="cFamilyName" msprop:Generator_ColumnVarNameInTable="columncFamilyName" msprop:Generator_ColumnPropNameInRow="cFamilyName" msprop:Generator_ColumnPropNameInTable="cFamilyNameColumn" msprop:Generator_UserColumnName="cFamilyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMiddleName" msprop:Generator_ColumnVarNameInTable="columncMiddleName" msprop:Generator_ColumnPropNameInRow="cMiddleName" msprop:Generator_ColumnPropNameInTable="cMiddleNameColumn" msprop:Generator_UserColumnName="cMiddleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cFirstName" msprop:Generator_ColumnVarNameInTable="columncFirstName" msprop:Generator_ColumnPropNameInRow="cFirstName" msprop:Generator_ColumnPropNameInTable="cFirstNameColumn" msprop:Generator_UserColumnName="cFirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cCMT" msprop:Generator_ColumnVarNameInTable="columncCMT" msprop:Generator_ColumnPropNameInRow="cCMT" msprop:Generator_ColumnPropNameInTable="cCMTColumn" msprop:Generator_UserColumnName="cCMT" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dNgayCap" msprop:Generator_ColumnVarNameInTable="columndNgayCap" msprop:Generator_ColumnPropNameInRow="dNgayCap" msprop:Generator_ColumnPropNameInTable="dNgayCapColumn" msprop:Generator_UserColumnName="dNgayCap" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nNoiCap" msprop:Generator_ColumnVarNameInTable="columnnNoiCap" msprop:Generator_ColumnPropNameInRow="nNoiCap" msprop:Generator_ColumnPropNameInTable="nNoiCapColumn" msprop:Generator_UserColumnName="nNoiCap" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cAlias" msprop:Generator_ColumnVarNameInTable="columncAlias" msprop:Generator_ColumnPropNameInRow="cAlias" msprop:Generator_ColumnPropNameInTable="cAliasColumn" msprop:Generator_UserColumnName="cAlias" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dDateOfBirth" msprop:Generator_ColumnVarNameInTable="columndDateOfBirth" msprop:Generator_ColumnPropNameInRow="dDateOfBirth" msprop:Generator_ColumnPropNameInTable="dDateOfBirthColumn" msprop:Generator_UserColumnName="dDateOfBirth" type="xs:dateTime" minOccurs="0" />
              <xs:element name="cAddress" msprop:Generator_ColumnVarNameInTable="columncAddress" msprop:Generator_ColumnPropNameInRow="cAddress" msprop:Generator_ColumnPropNameInTable="cAddressColumn" msprop:Generator_UserColumnName="cAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cPlaceOfBirth" msprop:Generator_ColumnVarNameInTable="columncPlaceOfBirth" msprop:Generator_ColumnPropNameInRow="cPlaceOfBirth" msprop:Generator_ColumnPropNameInTable="cPlaceOfBirthColumn" msprop:Generator_UserColumnName="cPlaceOfBirth" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cHomeNo" msprop:Generator_ColumnVarNameInTable="columncHomeNo" msprop:Generator_ColumnPropNameInRow="cHomeNo" msprop:Generator_ColumnPropNameInTable="cHomeNoColumn" msprop:Generator_UserColumnName="cHomeNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cHandNo" msprop:Generator_ColumnVarNameInTable="columncHandNo" msprop:Generator_ColumnPropNameInRow="cHandNo" msprop:Generator_ColumnPropNameInTable="cHandNoColumn" msprop:Generator_UserColumnName="cHandNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cEmail" msprop:Generator_ColumnVarNameInTable="columncEmail" msprop:Generator_ColumnPropNameInRow="cEmail" msprop:Generator_ColumnPropNameInTable="cEmailColumn" msprop:Generator_UserColumnName="cEmail" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cSex" msprop:Generator_ColumnVarNameInTable="columncSex" msprop:Generator_ColumnPropNameInRow="cSex" msprop:Generator_ColumnPropNameInTable="cSexColumn" msprop:Generator_UserColumnName="cSex" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMaritalStatus" msprop:Generator_ColumnVarNameInTable="columncMaritalStatus" msprop:Generator_ColumnPropNameInRow="cMaritalStatus" msprop:Generator_ColumnPropNameInTable="cMaritalStatusColumn" msprop:Generator_UserColumnName="cMaritalStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cNationality" msprop:Generator_ColumnVarNameInTable="columncNationality" msprop:Generator_ColumnPropNameInRow="cNationality" msprop:Generator_ColumnPropNameInTable="cNationalityColumn" msprop:Generator_UserColumnName="cNationality" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cContactPerson" msprop:Generator_ColumnVarNameInTable="columncContactPerson" msprop:Generator_ColumnPropNameInRow="cContactPerson" msprop:Generator_ColumnPropNameInTable="cContactPersonColumn" msprop:Generator_UserColumnName="cContactPerson" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cContactPersonAddress" msprop:Generator_ColumnVarNameInTable="columncContactPersonAddress" msprop:Generator_ColumnPropNameInRow="cContactPersonAddress" msprop:Generator_ColumnPropNameInTable="cContactPersonAddressColumn" msprop:Generator_UserColumnName="cContactPersonAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cContactPersonNo" msprop:Generator_ColumnVarNameInTable="columncContactPersonNo" msprop:Generator_ColumnPropNameInRow="cContactPersonNo" msprop:Generator_ColumnPropNameInTable="cContactPersonNoColumn" msprop:Generator_UserColumnName="cContactPersonNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cContactRelation" msprop:Generator_ColumnVarNameInTable="columncContactRelation" msprop:Generator_ColumnPropNameInRow="cContactRelation" msprop:Generator_ColumnPropNameInTable="cContactRelationColumn" msprop:Generator_UserColumnName="cContactRelation" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cContactEmail" msprop:Generator_ColumnVarNameInTable="columncContactEmail" msprop:Generator_ColumnPropNameInRow="cContactEmail" msprop:Generator_ColumnPropNameInTable="cContactEmailColumn" msprop:Generator_UserColumnName="cContactEmail" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fHeight" msprop:Generator_ColumnVarNameInTable="columnfHeight" msprop:Generator_ColumnPropNameInRow="fHeight" msprop:Generator_ColumnPropNameInTable="fHeightColumn" msprop:Generator_UserColumnName="fHeight" type="xs:double" minOccurs="0" />
              <xs:element name="fWeight" msprop:Generator_ColumnVarNameInTable="columnfWeight" msprop:Generator_ColumnPropNameInRow="fWeight" msprop:Generator_ColumnPropNameInTable="fWeightColumn" msprop:Generator_UserColumnName="fWeight" type="xs:double" minOccurs="0" />
              <xs:element name="cBloodGroup" msprop:Generator_ColumnVarNameInTable="columncBloodGroup" msprop:Generator_ColumnPropNameInRow="cBloodGroup" msprop:Generator_ColumnPropNameInTable="cBloodGroupColumn" msprop:Generator_UserColumnName="cBloodGroup" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fShoeSizeVN" msprop:Generator_ColumnVarNameInTable="columnfShoeSizeVN" msprop:Generator_ColumnPropNameInRow="fShoeSizeVN" msprop:Generator_ColumnPropNameInTable="fShoeSizeVNColumn" msprop:Generator_UserColumnName="fShoeSizeVN" type="xs:double" minOccurs="0" />
              <xs:element name="fShoeSizeJP" msprop:Generator_ColumnVarNameInTable="columnfShoeSizeJP" msprop:Generator_ColumnPropNameInRow="fShoeSizeJP" msprop:Generator_ColumnPropNameInTable="fShoeSizeJPColumn" msprop:Generator_UserColumnName="fShoeSizeJP" type="xs:double" minOccurs="0" />
              <xs:element name="fOverallSizeVN" msprop:Generator_ColumnVarNameInTable="columnfOverallSizeVN" msprop:Generator_ColumnPropNameInRow="fOverallSizeVN" msprop:Generator_ColumnPropNameInTable="fOverallSizeVNColumn" msprop:Generator_UserColumnName="fOverallSizeVN" type="xs:double" minOccurs="0" />
              <xs:element name="cOverallSizeJP" msprop:Generator_ColumnVarNameInTable="columncOverallSizeJP" msprop:Generator_ColumnPropNameInRow="cOverallSizeJP" msprop:Generator_ColumnPropNameInTable="cOverallSizeJPColumn" msprop:Generator_UserColumnName="cOverallSizeJP" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="bDeleted" msprop:Generator_ColumnVarNameInTable="columnbDeleted" msprop:Generator_ColumnPropNameInRow="bDeleted" msprop:Generator_ColumnPropNameInTable="bDeletedColumn" msprop:Generator_UserColumnName="bDeleted" type="xs:boolean" minOccurs="0" />
              <xs:element name="ContactPhuongXaID" msprop:Generator_ColumnVarNameInTable="columnContactPhuongXaID" msprop:Generator_ColumnPropNameInRow="ContactPhuongXaID" msprop:Generator_ColumnPropNameInTable="ContactPhuongXaIDColumn" msprop:Generator_UserColumnName="ContactPhuongXaID" type="xs:int" minOccurs="0" />
              <xs:element name="ContactQuanHuyenId" msprop:Generator_ColumnVarNameInTable="columnContactQuanHuyenId" msprop:Generator_ColumnPropNameInRow="ContactQuanHuyenId" msprop:Generator_ColumnPropNameInTable="ContactQuanHuyenIdColumn" msprop:Generator_UserColumnName="ContactQuanHuyenId" type="xs:int" minOccurs="0" />
              <xs:element name="ContactTinhThanh" msprop:Generator_ColumnVarNameInTable="columnContactTinhThanh" msprop:Generator_ColumnPropNameInRow="ContactTinhThanh" msprop:Generator_ColumnPropNameInTable="ContactTinhThanhColumn" msprop:Generator_UserColumnName="ContactTinhThanh" type="xs:int" minOccurs="0" />
              <xs:element name="PhuongXaID" msprop:Generator_ColumnVarNameInTable="columnPhuongXaID" msprop:Generator_ColumnPropNameInRow="PhuongXaID" msprop:Generator_ColumnPropNameInTable="PhuongXaIDColumn" msprop:Generator_UserColumnName="PhuongXaID" type="xs:int" minOccurs="0" />
              <xs:element name="QuanHuyenID" msprop:Generator_ColumnVarNameInTable="columnQuanHuyenID" msprop:Generator_ColumnPropNameInRow="QuanHuyenID" msprop:Generator_ColumnPropNameInTable="QuanHuyenIDColumn" msprop:Generator_UserColumnName="QuanHuyenID" type="xs:int" minOccurs="0" />
              <xs:element name="TinhThanhID" msprop:Generator_ColumnVarNameInTable="columnTinhThanhID" msprop:Generator_ColumnPropNameInRow="TinhThanhID" msprop:Generator_ColumnPropNameInTable="TinhThanhIDColumn" msprop:Generator_UserColumnName="TinhThanhID" type="xs:int" minOccurs="0" />
              <xs:element name="cFullName" msdata:ReadOnly="true" msdata:Expression="cFamilyName+' '+cMiddleName+' '+cFirstName" msprop:Generator_ColumnVarNameInTable="columncFullName" msprop:Generator_ColumnPropNameInRow="cFullName" msprop:Generator_ColumnPropNameInTable="cFullNameColumn" msprop:Generator_UserColumnName="cFullName" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblLongPlanVessel" msprop:Generator_TableClassName="tblLongPlanVesselDataTable" msprop:Generator_TableVarName="tabletblLongPlanVessel" msprop:Generator_TablePropName="tblLongPlanVessel" msprop:Generator_RowDeletingName="tblLongPlanVesselRowDeleting" msprop:Generator_UserTableName="tblLongPlanVessel" msprop:Generator_RowChangingName="tblLongPlanVesselRowChanging" msprop:Generator_RowEvHandlerName="tblLongPlanVesselRowChangeEventHandler" msprop:Generator_RowDeletedName="tblLongPlanVesselRowDeleted" msprop:Generator_RowEvArgName="tblLongPlanVesselRowChangeEvent" msprop:Generator_RowChangedName="tblLongPlanVesselRowChanged" msprop:Generator_RowClassName="tblLongPlanVesselRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nLongPlanVesselId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnLongPlanVesselId" msprop:Generator_ColumnPropNameInRow="nLongPlanVesselId" msprop:Generator_ColumnPropNameInTable="nLongPlanVesselIdColumn" msprop:Generator_UserColumnName="nLongPlanVesselId" type="xs:int" />
              <xs:element name="nVesselId" msprop:Generator_ColumnVarNameInTable="columnnVesselId" msprop:Generator_ColumnPropNameInRow="nVesselId" msprop:Generator_ColumnPropNameInTable="nVesselIdColumn" msprop:Generator_UserColumnName="nVesselId" type="xs:int" minOccurs="0" />
              <xs:element name="nCrewId" msprop:Generator_ColumnVarNameInTable="columnnCrewId" msprop:Generator_ColumnPropNameInRow="nCrewId" msprop:Generator_ColumnPropNameInTable="nCrewIdColumn" msprop:Generator_UserColumnName="nCrewId" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VesselName" msprop:Generator_ColumnVarNameInTable="columnVesselName" msprop:Generator_ColumnPropNameInRow="VesselName" msprop:Generator_ColumnPropNameInTable="VesselNameColumn" msprop:Generator_UserColumnName="VesselName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FullName" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" msprop:Generator_UserColumnName="FullName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dStart" msprop:Generator_ColumnVarNameInTable="columndStart" msprop:Generator_ColumnPropNameInRow="dStart" msprop:Generator_ColumnPropNameInTable="dStartColumn" msprop:Generator_UserColumnName="dStart" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dEnd" msprop:Generator_ColumnVarNameInTable="columndEnd" msprop:Generator_ColumnPropNameInRow="dEnd" msprop:Generator_ColumnPropNameInTable="dEndColumn" msprop:Generator_UserColumnName="dEnd" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nRankId" msprop:Generator_ColumnVarNameInTable="columnnRankId" msprop:Generator_ColumnPropNameInRow="nRankId" msprop:Generator_ColumnPropNameInTable="nRankIdColumn" msprop:Generator_UserColumnName="nRankId" type="xs:int" minOccurs="0" />
              <xs:element name="PlanID" msprop:Generator_ColumnVarNameInTable="columnPlanID" msprop:Generator_ColumnPropNameInRow="PlanID" msprop:Generator_ColumnPropNameInTable="PlanIDColumn" msprop:Generator_UserColumnName="PlanID" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblTrainingCrews" />
      <xs:field xpath="mstns:nTrainingCrewId" />
    </xs:unique>
    <xs:unique name="tblTrainingCourse_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblTrainingCourse" />
      <xs:field xpath="mstns:nTrainingCourse" />
    </xs:unique>
    <xs:unique name="tblCrew_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblCrew" />
      <xs:field xpath="mstns:nCrewId" />
    </xs:unique>
    <xs:unique name="tblLongPlanVessel_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblLongPlanVessel" />
      <xs:field xpath="mstns:nLongPlanVesselId" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_tblTrainingCrews_tblTrainingCourse" msdata:parent="tblTrainingCourse" msdata:child="tblTrainingCrews" msdata:parentkey="nTrainingCourse" msdata:childkey="nTrainingCourse" msprop:Generator_UserChildTable="tblTrainingCrews" msprop:Generator_ChildPropName="GettblTrainingCrewsRows" msprop:Generator_UserParentTable="tblTrainingCourse" msprop:Generator_UserRelationName="FK_tblTrainingCrews_tblTrainingCourse" msprop:Generator_RelationVarName="relationFK_tblTrainingCrews_tblTrainingCourse" msprop:Generator_ParentPropName="tblTrainingCourseRow" />
      <msdata:Relationship name="FK_tblTrainingCrews_tblCrew" msdata:parent="tblCrew" msdata:child="tblTrainingCrews" msdata:parentkey="nCrewId" msdata:childkey="nCrewId" msprop:Generator_UserChildTable="tblTrainingCrews" msprop:Generator_ChildPropName="GettblTrainingCrewsRows" msprop:Generator_UserParentTable="tblCrew" msprop:Generator_UserRelationName="FK_tblTrainingCrews_tblCrew" msprop:Generator_RelationVarName="relationFK_tblTrainingCrews_tblCrew" msprop:Generator_ParentPropName="tblCrewRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>